-
Re: what is wrong with my formula join collect?
@Deonizia Egan Glad your formula is working. In case you are unaware, when trying to match data to a reference, in many Functions there is a requirement that both the reference and the matching data …1 · -
Re: is it possible to create a search form to query existing data in a sheet?
Hey @AnkaPG In the screenshot above, the blurred column is 'Name'. There were also 7 or 8 hidden fields in the sheet that I had doing lookups, based on the 3 entries that the submitter made. Because …1 · -
Re: Errors when using Collect function
Hey @David Hinman What column type is the column where your Max/Collect formula sits? It also needs to be a date type column since the data you are collecting is a Date. Kelly1 · -
Re: Default one field value based on item selected in another fields dropdown
Hey @k_Hunter001 I think you are asking for an IF statement to populate your UAT1 column? For instance IF(Category@row<>"", IF(OR(Category@row="WD-Enhancement Tier 1 (Existing Pr…1 · -
Re: Formula to Count Ages of Orders
Hey @Galadriel975 You will need a field in your main sheet to calculate how much time, per row, has passed. If you don't have a column for this then yes, you need this helper column. I also assumed y…1 ·